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