UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'frJkFWsc43fLJ+Z3VwldvvRx1RA+wKVi3VNRQdypXkw='
WHERE
key_id = '4e169d66287b2087143aaa55c7afd1a5014a516a0a345e18cd67d7dda2f49dce'
AND (
token = 'frJkFWsc43fLJ+Z3VwldvvRx1RA+wKVi3VNRQdypXkw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)