UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xVTH6W+tPqlaQwan4rFxseFSi2PJPhvWLCYLP856kU8='
WHERE
key_id = '7748d1190406dbd30ba2c800e1b9100135104b3f3965bc1f17b02993927affef'
AND (
token = 'xVTH6W+tPqlaQwan4rFxseFSi2PJPhvWLCYLP856kU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)