UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X5XoTgGBjhvTqPA23eFUIaG32ghoR0PcKkwT8nwp3x0='
WHERE
key_id = '8c9b8051f1517ff45a3044e5ecb6aa55c24d65f39ae067db3a52528ce25eb043'
AND (
token = 'X5XoTgGBjhvTqPA23eFUIaG32ghoR0PcKkwT8nwp3x0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)