UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bt5wkvwMESjH0/3W5L45X0W1S/m7jZq2ehGFWstos0Q='
WHERE
key_id = '1c23e02218249d042ce904a4d6afda6f46e30ff3bd65f516683fe5c259a8dfc5'
AND (
token = 'bt5wkvwMESjH0/3W5L45X0W1S/m7jZq2ehGFWstos0Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)