UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OfYN5ujnkhW7v1EDIoXg4TFL5vzCxBbPcVug412jfO0='
WHERE
key_id = '8a86a8951dd55d7c56cb50d970ebe7b8055dfddd541fb2ae762667ae4e5bd365'
AND (
token = 'OfYN5ujnkhW7v1EDIoXg4TFL5vzCxBbPcVug412jfO0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)