UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kqNOWmgLYd6ZZvlElJGwMfGFk19hqFZLa0/ZsavJVWM='
WHERE
key_id = 'ef5fe40d87c20c50c068b1e9d4900efd8d25e911ee77920e1307252b45b201cc'
AND (
token = 'kqNOWmgLYd6ZZvlElJGwMfGFk19hqFZLa0/ZsavJVWM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)