UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qgOr9kiwPvRTXA2MtEV6Is+hm/ap/7vFmOJfytKFVT8='
WHERE
key_id = '77724ea1f1cfa8394bcc98a80fb5a47647daf015a59af1c8442835ed4eee2bf1'
AND (
token = 'qgOr9kiwPvRTXA2MtEV6Is+hm/ap/7vFmOJfytKFVT8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)