UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fD97f2x8rLSt2r8I3pNyu9BJjNYHGzFhpK6XTeW7fOg='
WHERE
key_id = '3ea9eaadd4163b626fd63bec0683442eb57ec880344a4c23237831441882abf1'
AND (
token = 'fD97f2x8rLSt2r8I3pNyu9BJjNYHGzFhpK6XTeW7fOg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)