UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0cqaRMd6L52TUQM9zG78HNbeHtIt2pbM2jZOqznO5vg='
WHERE
key_id = 'b467cf4bcd7876bb81f6444e42fb691bfc0e0c17e999aed9ce7740f8ed9626d9'
AND (
token = '0cqaRMd6L52TUQM9zG78HNbeHtIt2pbM2jZOqznO5vg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)