UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z+DV7LEC1uPMR6A/lIV6zwoKw0YRl0eAh2shRYnrv+k='
WHERE
key_id = '1d9f52f5d1a3b84f394c6fed30a8c12069106c016b5768a6b681623176ac4121'
AND (
token = 'Z+DV7LEC1uPMR6A/lIV6zwoKw0YRl0eAh2shRYnrv+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)