UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '11i0QNIdPe29A3YAz5bLoUvVQmVtXMAh4KLITL1BMx8='
WHERE
key_id = 'b99ef78e9003c577d05bfcc636f9570baf0bf74995c679207ea9174ce622df40'
AND (
token = '11i0QNIdPe29A3YAz5bLoUvVQmVtXMAh4KLITL1BMx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)