UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lUqTf2NBaN8O9kcpZjmBiP+KwQA8crSrJICQYv7i2bk='
WHERE
key_id = 'e8faf9b75a63ba8e6d2596324bca3449a9a212637e15388913b2081b4dadea35'
AND (
token = 'lUqTf2NBaN8O9kcpZjmBiP+KwQA8crSrJICQYv7i2bk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)