UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TFaTuwplr5gccKGjLy5GqzywMM7WfDHmAtozX8dKlOg='
WHERE
key_id = 'f24f51a1f5203009516ecd7b439f4e5636c2473a378c42a3af809cbf1e9b2472'
AND (
token = 'TFaTuwplr5gccKGjLy5GqzywMM7WfDHmAtozX8dKlOg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)