UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R70gow48BkEekMYcFzS3TEE4L/PsqYyo3VgoNDwV9/A='
WHERE
key_id = '5b14e8669daa320bb45933cd11efb56104adb5dfdd987c5caf26c28b2e026fcc'
AND (
token = 'R70gow48BkEekMYcFzS3TEE4L/PsqYyo3VgoNDwV9/A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)