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