UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7jRg0aYEUZ+mghbGXdJYdryeA1yl5emYGaJO4Ps8mjE='
WHERE
key_id = '3e0a74567f85741f8e7a6720c79daae0c3173264cc7e4adddd36edbfcc06e523'
AND (
token = '7jRg0aYEUZ+mghbGXdJYdryeA1yl5emYGaJO4Ps8mjE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)