UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hwrNeFNjK1a/6EuNBMvmHcLlOBBMuX5/4VNygToBGOI='
WHERE
key_id = '502dc3930aeff7b4803ec300b9bd1feb117e21976b1763d0474232ff8885d7bc'
AND (
token = 'hwrNeFNjK1a/6EuNBMvmHcLlOBBMuX5/4VNygToBGOI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)