UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nnVv70gQUo9Ba1CVIPxDoGqt196ESuOATdrGlVW0JJw='
WHERE
key_id = 'da82f966a27fe9e8bc3cca4ee473796ff8703cd16f9beaea8df4fdaa188fb60b'
AND (
token = 'nnVv70gQUo9Ba1CVIPxDoGqt196ESuOATdrGlVW0JJw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)