UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/SFy5jo+d7amfnOGwa8xgjANC5pwCSb7Z5J+w8pQuR4='
WHERE
key_id = '9455cae5ae570749ac75b27a388b9ad540edf37ce28d84abefa8d40862f029f5'
AND (
token = '/SFy5jo+d7amfnOGwa8xgjANC5pwCSb7Z5J+w8pQuR4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)