UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Jgn/5GUbG3YCVeX7FYCvp2tyvWHW3MTT3wHkglvvHzQ='
WHERE
key_id = '0dd7e3f4ffd7edb6c6390740a9bf1728bd9ffd8b3b09741b8a77eadc00238a4e'
AND (
token = 'Jgn/5GUbG3YCVeX7FYCvp2tyvWHW3MTT3wHkglvvHzQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)