UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZBK5WfEyf11QqRn08Hnq7iX35lUUCTIMP+FYNNS5K24='
WHERE
key_id = 'd57b0fbafaba396f936c4e7ad5b08c8ae94bfa843a0bd6d5da41d5e74780a29b'
AND (
token = 'ZBK5WfEyf11QqRn08Hnq7iX35lUUCTIMP+FYNNS5K24='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)