UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W+0BRJD1+qli+S+rlN2EufSsNt17suz6Gsb96+t3no8='
WHERE
key_id = 'a4fd6cd792fd540dc00a2ef3fb4d85f7004fda90494452c5497eca62a0a0d54a'
AND (
token = 'W+0BRJD1+qli+S+rlN2EufSsNt17suz6Gsb96+t3no8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)