UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0G0pNrOXCa3JsVoRFp8F48/+EwBIZFIpNARjeihFbzU='
WHERE
key_id = 'dc1e79e74efa3965100e1032c8463963b0a21c7da305e3934d48ab2d1ce2faac'
AND (
token = '0G0pNrOXCa3JsVoRFp8F48/+EwBIZFIpNARjeihFbzU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)