UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pU65SExa3FhBMK12HYdbG9j2+cnu5CrS6sIGVcZE0Ko='
WHERE
key_id = '1902b2b06aa397a1e9a72c14fb85656ad816693dd0aa8a770d62d27136b23afc'
AND (
token = 'pU65SExa3FhBMK12HYdbG9j2+cnu5CrS6sIGVcZE0Ko='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)