UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aGQfBNQvDYQcKphCYkOuUQvhyjwBsOJE78a/geD7fPU='
WHERE
key_id = '8dc16f589cf5f4aa52552accdd83028c42069bd561bb745a1814a5a4335fe147'
AND (
token = 'aGQfBNQvDYQcKphCYkOuUQvhyjwBsOJE78a/geD7fPU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)