UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0mF/oPrsaZIjW8mniCJp55TAxmzRpPUj0RUfY4y6aqU='
WHERE
key_id = '65af9ec0b91b3975cc445cf156b22cc46e30e95e77f5a5f84bbe33c19e1b51e9'
AND (
token = '0mF/oPrsaZIjW8mniCJp55TAxmzRpPUj0RUfY4y6aqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)