UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zoHTDdEMSKHAzel1SU4gANSHCNJtjKD58Rp+tOeIHdc='
WHERE
key_id = '25c327f3fed855246b2016910e55e35d0b22b724234b176bfa6218f9a347bf3e'
AND (
token = 'zoHTDdEMSKHAzel1SU4gANSHCNJtjKD58Rp+tOeIHdc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)