UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RQWihJ58kkPii1fq/6WtKLDFGsEoNCGg0I/H6Dv7Du4='
WHERE
key_id = 'c3492f2c7d16168c04e056a60c6cca53d73ea17cc9eec4e882b4b025c6719dd7'
AND (
token = 'RQWihJ58kkPii1fq/6WtKLDFGsEoNCGg0I/H6Dv7Du4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)