UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hD6vr1EFhtEeAO84ZBOvq6r2XBY9s91H17T7u7kwOFM='
WHERE
key_id = '07b0f178a1f909cde8d33c4a8c942228261e18372295eea099df82cc75db3616'
AND (
token = 'hD6vr1EFhtEeAO84ZBOvq6r2XBY9s91H17T7u7kwOFM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)