UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '00vlXKreWMI8GZouaAM/Jtpuu1drrGKOGeAHPYiCxME='
WHERE
key_id = 'b93a3f4a44f21808dc0aaa52cbb26f5e970477d34a3de71e77bb1b80ea49db54'
AND (
token = '00vlXKreWMI8GZouaAM/Jtpuu1drrGKOGeAHPYiCxME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)