UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AvQjyWH9qGrhhPKnggGr5zvxq6OBHFNOmXVj/9PkrG4='
WHERE
key_id = '2fbb31c33c258ee1bcb6fc2b3bd68d08af5d332e77a977e607c8e2eaea712ae2'
AND (
token = 'AvQjyWH9qGrhhPKnggGr5zvxq6OBHFNOmXVj/9PkrG4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)