UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SoRa0ptQ8hFyeFKF7jEmYCxHbrMIO+6Mg/E+XD+YHxI='
WHERE
key_id = 'f47a6d518e2b0364106724c3ebe0cc7b5c1c4e0f040b7e489f05d43421fac274'
AND (
token = 'SoRa0ptQ8hFyeFKF7jEmYCxHbrMIO+6Mg/E+XD+YHxI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)