UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'huiPOlU6XXZsHVwqE3JZWVv6ZE+mLtnKp2D2n31VlP8='
WHERE
key_id = '2f4fa566a300c8db8d464f7f6eb7dfe2c33766ecc84be66f29a6f9cc74ac4628'
AND (
token = 'huiPOlU6XXZsHVwqE3JZWVv6ZE+mLtnKp2D2n31VlP8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)