UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3gHZEoBvgPbOqZb3gq07GtSweAVrCBF4z0Cm4yxFCm4='
WHERE
key_id = '67e94c2be78ec4d87c2325f48e78e9c18b193cc764adad8263ad8b8d7a56d8dc'
AND (
token = '3gHZEoBvgPbOqZb3gq07GtSweAVrCBF4z0Cm4yxFCm4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)