UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C1u2qsRt8cKouy7NWcjTXUUBWjwNlRZYgUpf0jZzuy8='
WHERE
key_id = '476b545276f900131b78596242bfbb8020f5530ce63b8fc9372d3dd894274a2e'
AND (
token = 'C1u2qsRt8cKouy7NWcjTXUUBWjwNlRZYgUpf0jZzuy8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)