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